2014-01-24 - 10939 - Enhancement - BI - Add two fields to OSA132 source #CrystalReportsSupport
ENHANCEMENT
10939 - BI - Add two fields to OSA132 source
Requirement Summary
Need to add Size/Grid & UPC fields to ZMP_OOCON_Q005 BEx Query.
Admin Info
Purpose
|
Need to add size/grid and upc to ZMP_OOCON_Q005 source.
|
Requested By
|
Danny Moult
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
01/24/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZMP_OOCON_Q005
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
1. Need to add Size/Grid & UPC fields to ZMP_OOCON_Q005 BEx Query in BPD(BW 7.3 Development) and transport it to BPQ(BW 7.3 Quality).
2. Update the required reports to reflect these fields.
Solution Summary
1. Need to create an open transport request.
2. Need to add Size/Grid characteristic 0AF_GRDVAL and exlude UPC label as it is missing in the source.
3. Check if the query meets the QA Standards as per NEC checklist.
4. Need to collect the query into the transport request.
5. Transport the request into BPQ and BPP.
6. Update the required crystal report with these new fields.
Test Plan
S.No
|
Test Scenario
|
Expected Results
|
1
|
Test the Enhanced query functionality in BPQ.
|
Query should be successfully validated in BPQ.
|
2
|
Report should be checked against NEC standard checklist.
|
Report should pass the NEC reports standard checklist.
|
Solution Details
1. Need to create an Open transport request as the Query is already moved to quality/production and locked with another request.
2. Need to add Size/Grid characteristic 0AF_GRDVAL to the to Query ZMP_OOCON_Q005 in BPD.
3. Check if the query meets the QA Standards as per NEC standard checklist.
4. Need to collect the query into the open transport created above.
5. Transport the changes to BPQ for testing and move it to BPP after successful testing in quality.
6. Update the required crystal report with this new field.
Issues
UPC field is not added to the BEx Query since the field is not available in the source on which the BEx query is defined.